soundex function in sql

The SOUNDEX () function is an algorithm that converts any text string into a letter pattern that describes the speech representation.He considered similar to pronounced characters and bytes, and was able to compare the pronunciation of the text

-- Sentence skill -- Data Operations SELECT -- retrieve data rows and columns from database tables INSERT -- add new data rows to the database table DELETE -- DELETE data rows from a database table UPDATE -- UPDATE data in the database table -- Data

Comparison of common functions for SQL Server to Oracle 1. Absolute ValueS: Select ABS (-1) ValueO: Select ABS (-1) value from dual 2. INTEGER (large)S: Select ceiling (-1.001) ValueO: Select Ceil (-1.001) value from dual 3. Round (small)S: Select

PL/SQL single-row functions and group functions A function is a program with zero or multiple parameters and a return value. Oracle has a series of built-in functions in SQL, which can be called SQL or PL/SQL statements. functions are mainly divided

  -- Sentence skill 1. Data OperationsSelect -- retrieve data rows and columns from database tablesInsert -- add new data rows to the database tableDelete -- delete data rows from a database tableUpdate -- update data in the database table 2.

PL/SQL single-line functions and group functionsA function is a program that has 0 or more parameters and has a return value. Oracle built a series of functions in SQL that can be called SQL or PLFunctions are divided into two main categories:Single-

String function string comparison function if the result length is greater than the maximum value of the max_allowed_packet system variable, the return value of the string value function is NULL. See section 7.5.2 "Adjust server Parameters ". String

String functionsstring comparison functionsIf the length of the result is greater than the maximum value of the Max_allowed_packet system variable, the return value of the string value function is null. See section 7.5.2, "Tuning server parameters."

First, before the introduction of the use of functions to process data, the use of DBMS (database management system) to deal with the data caused by the problem!1. Unlike almost all DBMS support for SQL statements (such as Select), each DBMS has a

The Code is as follows: DROPTABLE data table name (permanently delete a data table) delete record: deletefrom table name where condition (rqjs_id ***) update all records: update table name set field name value update by condition: update table name